﻿<!--//=============================================================
    // Copyright (C) 2015 福流网络
    // 作 者：钟星星
    // 日 期：2016-01-15
    // 描 述:  挂账自定义查询
    // 版 本：1.00
    // 修改历史纪录
    // 版 本  修改时间      修改人            修改内容
    //=============================================================-->

<div id="QueryItem">

    <div class="col2" id="query_item_payee_dt"><table class="query_table"><tr><td class="label">收款日期</td><td class="exp" style="display: none"><select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select></td><td><input name="payee_dt" class="mini-datepicker" style="width:100%;" data="payee_dt_data" /></td><td><input name="payee_dt_1" class="mini-datepicker" style="width:100%;" data="payee_dt_data" /></td></tr></table></div>
    <div class="col2" id="query_item_payback_dt"><table class="query_table"><tr><td class="label">回款日期</td><td class="exp" style="display: none"><select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select></td><td><input name="payback_dt" class="mini-datepicker" style="width:100%;" data="payback_dt_data" /></td><td><input name="payback_dt_1" class="mini-datepicker" style="width:100%;" data="payback_dt_data" /></td></tr></table></div>
    <div class="col2" id="query_item_borrowmoney_dt"><table class="query_table"><tr><td class="label">借款时间</td><td class="exp" style="display: none"><select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select></td><td><input name="borrowmoney_dt" class="mini-datepicker" style="width:100%;" data="borrowmoney_dt_data" /></td><td><input name="borrowmoney_dt_1" class="mini-datepicker" style="width:100%;" data="borrowmoney_dt_data" /></td></tr></table></div>
    <div class="col2" id="query_item_borrowmoneyaudit_dt"><table class="query_table"><tr><td class="label">借款审核时间</td><td class="exp" style="display: none"><select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select></td><td><input name="borrowmoneyaudit_dt" class="mini-datepicker" style="width:100%;" data="borrowmoneyaudit_dt_data" /></td><td><input name="borrowmoneyaudit_dt_1" class="mini-datepicker" style="width:100%;" data="borrowmoneyaudit_dt_data" /></td></tr></table></div>
    <div class="col2" id="query_item_payment_dt"><table class="query_table"><tr><td class="label">付款时间</td><td class="exp" style="display: none"><select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select></td><td><input name="payment_dt" class="mini-datepicker" style="width:100%;" data="payment_dt_data" /></td><td><input name="payment_dt_1" class="mini-datepicker" style="width:100%;" data="payment_dt_data" /></td></tr></table></div>
    <div class="col2" id="query_item_payment_audit_dt"><table class="query_table"><tr><td class="label">付款审核时间</td><td class="exp" style="display: none"><select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select></td><td><input name="payment_audit_dt" class="mini-datepicker" style="width:100%;" data="payment_audit_dt_data" /></td><td><input name="payment_audit_dt_1" class="mini-datepicker" style="width:100%;" data="payment_audit_dt_data" /></td></tr></table></div>

    <div class="col1" id="query_item_payee_status_names">
        <table class="query_table">
            <tr>
                <td class="label">回款状态</td>
                <td class="exp" style="display: none">
                    <select>
                        <option value="=">等于</option>
                        <option value=">">大于</option>
                        <option value="<">小于</option>
                        <option value="between">在..之间</option>
                    </select>
                </td>
                <td>
                    <select style="width:100%; margin-left: 4px;" name="payee_status_names" showclose="true" multiselect="true" class="mini-combobox" oncloseclick="onCloseClick">
                        <option value=""></option>
                        <option value="未回款">未回款</option>
                        <option value="回款中">回款中</option>
                        <option value="已回款">已回款</option>
                    </select>

                </td>
            </tr>
        </table>
    </div>
    <div class="col1" id="query_item_use_no"><table class="query_table"><tr><td class="label">自编号</td><td class="exp" style="display: none"><select><option value="like">包含</option><option value="=">等于</option><option value=" not like">不包含</option> <option value="<>">不等于</option> </select></td><td><input name="use_no" class="mini-textbox" style="width:100%;" data="use_no_data" /></td></tr></table></div>
    <div class="col1" id="query_item_bill_no"><table class="query_table"><tr><td class="label">结算单号</td><td class="exp" style="display: none"><select><option value="like">包含</option><option value="=">等于</option><option value=" not like">不包含</option> <option value="<>">不等于</option> </select></td><td><input name="bill_no" class="mini-textbox" style="width:100%;" data="bill_no_data" /></td></tr></table></div>
    
    <div class="col1" id="query_item_customer_name">
        <table class="query_table">
            <tr>
                <td class="label">客户</td>
                <td class="exp" style="display: none">
                    <select>
                        <option value="=">等于</option>
                        <option value=">">大于</option>
                        <option value="<">小于</option>
                        <option value="between">在..之间</option>
                    </select>
                </td>
                <td>
                    <div id="customer_name" name="customer_name" class="mini-autocomplete" style="width:100%;float: left;" popupwidth="400" allowinput="true" textfield="short" valuefield="short"
                         showclose="true" valuefromselect="true" url="../../../Share/GetJsonList?tablename=t_base_objs&fieldnames=id,zucode,short&where=zclass_id=100 and stop_yn=0&searchField=short,zucode" oncloseclick="onCloseClick">
                        <div property="columns">
                            <div header="id" field="id" width="0"></div>
                            <div header="编号" field="zucode"></div>
                            <div header="简称" field="short"></div>
                        </div>
                    </div>
                </td>
            </tr>
        </table>
    </div>
    
    <div class="col1" id="query_item_company_name">
        <table class="query_table">
            <tr>
                <td class="label">所属公司</td>
                <td class="exp" style="display: none">
                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                </td>
                <td>
                    <select style="width:100%; margin-left: 4px;" name="company_name" class="mini-combobox">
                        <option value=""></option>
                        <option value="华报报关公司">华报报关公司</option>
                        <option value="华物报关公司">华物报关公司</option>
                    </select>

                </td>
            </tr>
        </table>
    </div>

    <div class="col1" id="query_item_arp_type_name">
        <table class="query_table">
            <tr>
                <td class="label">收款方式</td>
                <td class="exp" style="display: none">
                    <select>
                        <option value="=">等于</option>
                        <option value=">">大于</option>
                        <option value="<">小于</option>
                        <option value="between">在..之间</option>
                    </select>
                </td>
                <td>
                    <select style="width:100%; margin-left: 4px;" id="arp_type_name" name="arp_type_name" class="mini-combobox">
                        <option value=""></option>
                        <option value="挂账">挂账</option>
                        <option value="现金">现金</option>
                        <option value="转账">转账</option>
                    </select>
                </td>
            </tr>
        </table>
    </div>
    
    <div class="col1" id="query_item_borrowmoney_state">
        <table class="query_table">
            <tr>
                <td class="label">借款状态</td>
                <td class="exp" style="display: none">
                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                </td>
                <td>
                    <select style="width:100%; margin-left: 4px;" name="borrowmoney_state" class="mini-combobox">
                        <option value=""></option>
                        <option value="未借款">未借款</option>
                        <option value="已借款">已借款</option>
                    </select>

                </td>
            </tr>
        </table>
    </div>
    
    <div class="col1" id="query_item_borrowmoneyaudit_state">
        <table class="query_table">
            <tr>
                <td class="label">借款审核状态</td>
                <td class="exp" style="display: none">
                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                </td>
                <td>
                    <select style="width:100%; margin-left: 4px;" name="borrowmoneyaudit_state" class="mini-combobox">
                        <option value=""></option>
                        <option value="未借款审核">未借款审核</option>
                        <option value="已借款审核">已借款审核</option>
                    </select>

                </td>
            </tr>
        </table>
    </div>
    
    <div class="col1" id="query_item_payment_state">
        <table class="query_table">
            <tr>
                <td class="label">付款状态</td>
                <td class="exp" style="display: none">
                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                </td>
                <td>
                    <select style="width:100%; margin-left: 4px;" name="payment_state" class="mini-combobox">
                        <option value=""></option>
                        <option value="未付款">未付款</option>
                        <option value="已付款">已付款</option>
                    </select>

                </td>
            </tr>
        </table>
    </div>
    
    <div class="col1" id="query_item_payment_audit_state">
        <table class="query_table">
            <tr>
                <td class="label">付款审核状态</td>
                <td class="exp" style="display: none">
                    <select><option value="=">等于</option><option value=">">大于</option><option value="<">小于</option><option value="between">在..之间</option></select>
                </td>
                <td>
                    <select style="width:100%; margin-left: 4px;" name="payment_audit_state" class="mini-combobox">
                        <option value=""></option>
                        <option value="未付款审核">未付款审核</option>
                        <option value="已付款审核">已付款审核</option>
                    </select>

                </td>
            </tr>
        </table>
    </div>
    
    
    <div class="col2" id="">
        <table class="query_table">
            <tr>
                <td class="label">会计期间</td>
                <td>
                    <div id="period_name" name="period_name" class="mini-autocomplete" style="width:100%" popupwidth="500" allowinput="true" textfield="periodEndDt" valuefield="id" value="0" onvaluechanged="commentValueChanged"
                         showclose="true" valuefromselect="true" url="../../../Share/GetJsonList?tablename=t_fin_account_period&fieldnames=id,period_name,period_begin_dt,period_end_dt,( CONVERT(varchar(100),period_begin_dt ,23) + %2B + '/' + %2B +  CONVERT(varchar(100),period_end_dt,23) ) as periodEndDt&searchField=period_name" oncloseclick="onCloseClick">
                        <div property="columns">
                            <div header="简称" field="period_name"></div>
                            <div header="开始时间" field="period_begin_dt"></div>
                            <div header="结束时间" field="period_end_dt"></div>
                        </div>
                    </div>
                </td>
            </tr>
        </table>
    </div>
    <div id="query_item_kjqj_dt" style="display:none">
        <table class="query_table">
            <tr>
                <td>
                    <input id="txtpayee_dt_1" name="payee_dt_1" class="mini-hidden" style="width:100%;" data="payee_dt_data" />
                    <input id="txtpayee_dt_2" name="payee_dt_2" class="mini-hidden" style="width:100%;" data="payee_dt_data" />
                </td>

            </tr>
        </table>
    </div>

  

</div>



<script type="text/javascript">

    function onCloseClick(e) {
        var obj = e.sender;
        obj.setText("");
        obj.setValue("");
    }
    //会计期间下拉框改变事件
    function commentValueChanged(e) {
        if (e.value != "") {
            var beginDt = e.selecteds[0].period_begin_dt;
            var endDt = e.selecteds[0].period_end_dt;
            mini.get("txtpayee_dt_1").setValue(beginDt);
            mini.get("txtpayee_dt_2").setValue(endDt);
        } else {
            mini.get("txtpayee_dt_1").setValue("");
            mini.get("txtpayee_dt_2").setValue("");

        }
    }


</script>
